<cfoutput>
<cfif isdefined("session.ReceiptNum")>

 <CFQUERY NAME="getprod" DATASOURCE="#dsn#">
select *
from tbltransactions
where ReceiptNum = #session.ReceiptNum#
</CFQUERY>
<cfif #getprod.recordcount# gte 1>

<cfset session.TransType = "VOID">

<cfelse>

<cfset session.TransType = "SALE">

</cfif>

</cfif>

<cflocation url="products.cfm">


</cfoutput>
